| Value | Color |
|---|---|
| \e[0;30m | Black |
| \e[0;31m | Red |
| \e[0;32m | Green |
| \e[0;33m | Yellow |
| \e[0;34m | Blue |
| \e[0;35m | Purple |
Discover gists
| Полезные ключи программы psql | |
| -U - Указываем пользователя, например postgres | |
| -W - Приглашение на ввод пароля | |
| -d название_БД - Подключение к БД название_БД | |
| -h имя_хоста - Подключение к хосту имя_хоста | |
| -p порт - По какому порту постгря ожидает подключения | |
| -c команда - Выполнение команды SQL без выхода в интерактивный режим | |
| -f file.sql - Выполнение команд из файла file.sql | |
| -S - Однострочный режим, то есть, переход на новую строку будет выполнять запрос (избавляет от ; в конце конструкции SQL) |
| Visual Studio Code frequently crashes linux. Using NVIDIA GPU | |
| 1. Open command pallete (Ctrl + Shift + P) | |
| 2. Enter "Preferences: Configure Runtime Arguments" | |
| 3. Add config: "disable-hardware-acceleration": true | |
| 4. Restart VS Code |
I’m sharing this guide because I spent a lot of time troubleshooting SSL errors while setting up Poste.io behind Dokploy. If you are using Dokploy, you likely noticed that the Let's Encrypt certificates managed by Traefik work perfectly for the web dashboard but aren't automatically applied to the mail server ports (25, 587, 993, 995, etc.). This leads to "SSL/TLS Handshake" errors in external clients like Gmail or Outlook.
When trying to generate certificates inside Poste.io itself using the built-in Let's Encrypt client, I constantly hit this error:
LEScript.ERROR: 400 ... Unable to update challenge :: authorization must be pending
Instead of forcing Poste.io to get its own certificate, this method "feeds" Dokploy's existing certificates into the Poste.io container. This ensures that the Full Chain (Leaf + Intermediate certificates) is present, which is r
As requested in netdev, this gist contains the stacks leading into skb:kfree_skb:
The easiest way to look at the results is the flamegraphs, where reason is the top frame.
The results are from v6.1.38.
Hyprland is not available by default on Ubuntu 24.04 so instead we can utilize the Nix package manager and Home Manager.
The benefit of the Nix package manager compared to others in this case is that
the package and dependencies of Nix packages is immutable and self
contained. This means that the entire setup is contained to a separate /nix
| name | rodin |
|---|---|
| description | Interlocuteur socratique pour discussions sociétales profondes — anti-chambre d'écho |
Tu es Rodin, un interlocuteur intellectuel exigeant. Tu incarnes ce rôle pour toute la durée de la conversation. Ne brise jamais le personnage.
- Lis et intègre la synthèse portrait du portrait de l'utilisateur : [OPTIONEL A FAIRE DE VOTRE COTÉ] — c'est ton contexte permanent sur ton interlocuteur. Ne la résume pas, ne la mentionne pas. Intègre-la silencieusement.
Major 2025 Update: PostgreSQL now recommends identity columns over serial types. Drizzle has fully embraced this change.
import { pgTable, integer, text, timestamp, varchar } from 'drizzle-orm/pg-core';